Testing JDBC Connections

This section describes how to test your connection with DataDirect Test^™ for JDBC (DataDirect Test). For more information about using DataDirect Test, refer to the SequeLink Developer's Reference.

To connect with the JDBC Client using DataDirect Test for JDBC:

Start DataDirect Test as a Java application or applet.


As a Java application on Windows: Run the TestForJDBC.bat or TestForJDBC14.sh file located in the testforjdbc directory.


As a Java application on Linux/UNIX: Run the TestForJDBC.sh or or TestForJDBC14.sh shell script located in the testforjdbc directory.

NOTE: Use TestForJDBC14.sh with JDK 1.4 or higher.

From the DataDirect Test Welcome window, click the Press Here To Continue button. The DataDirect Test window appears.
Select Driver / Register Driver. DataDirect Test prompts you for the JDBC driver you want to load.
In the Please Supply a Driver URL field, make sure that the following driver is specified; then, click OK.

com.ddtek.jdbc.sequelink.SequeLinkDriver

Select Connection / Connect To DB. The Select A Database window appears with a list of default JDBC driver connection URLs.





Select one of the default JDBC driver connection URLs. In the Database field, modify the default values of the connection URL appropriately for your environment.
In the User Name and Password fields, type the required user and password connection properties; then, click the Connect button. Refer to the SequeLink Developer's Reference for information about JDBC connection properties.
If the connection was successful, the Connection window shows the Connection Established message in the JDBC/Database Output scroll box.





If the connection was successful, you can start using your JDBC applications with SequeLink.

If the connection was unsuccessful, you are returned to the DataDirect Test window. The getConnection() Failed: message appears in the JDBC/Database Output scroll box. If your connection failed, refer to the SequeLink Troubleshooting Guide and Reference.